{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "=========Supplier============\n",
      "中山市科兴达智能科技有限公司,2\n",
      "广西博唯信息科技有限公司,2\n",
      "广东蓝凌科技有限公司；,2\n",
      "河北先导建筑智能化工程有限公司,4\n",
      "广西邦华智能科技有限公司,2\n",
      "广西祥好电子有限公司,2\n",
      "周口杰威科教设备有限公司,2\n",
      "恩施州创新世纪电脑发展有限公司,2\n",
      "甘肃鼎晨商贸有限责任公司,2\n",
      "抚顺市新抚区格拓电脑耗材经销部,3\n",
      "张家口博信达科贸有限公司,2\n",
      "航天信息股份有限公司,2\n",
      "张家口龙腾电子科技有限公司,2\n",
      "抚顺市新抚区添科办公设备经销中心,4\n",
      "佛山市大昌科技有限公司,3\n",
      "宁夏安盈环保科技工程有限公司,2\n",
      "广东信兴科技有限公司,3\n",
      "许昌市镐鸣科技有限公司,2\n",
      "沈阳觥鼎商务咨询有限公司,2\n",
      "抚顺市新抚区泰合办公设备销售中心,3\n",
      "辽源市恒诚办公设备有限公司,3\n",
      "抚顺市新抚区文达办公设备销售中心,2\n",
      "中国电信集团系统集成有限责任公司,2\n",
      "北京美福科技有限公司,2\n",
      "广东利浩信息科技有限公司,3\n",
      "抚顺市新抚区金亿得物资装备经销处,2\n",
      "广州依讯计算机有限公司,2\n",
      "长城计算机软件与系统有限公司,2\n",
      "辽宁纬恒科技发展有限公司,2\n",
      "=========Consumer============\n",
      "中山市基础地理信息中心,446000.0\n",
      "酒泉市瓜州县第一中学,409160.0\n",
      "大同煤矿集团有限责任公司第二中学校,74160.0\n",
      "周口市第四初级中学,441600.0\n",
      "西安市国土资源局,568000.0\n",
      "丽水市莲都区招投标中心,3593650.0\n",
      "中山市黄圃镇马新初级中学,124790.0\n",
      "深圳市中网彩网络技术有限公司,337700.0\n",
      "辽宁省卫生信息中心,948500.0\n",
      "NNZC2014-10675A-A南宁市现代教育技术中心,706000.0\n",
      "卢氏县城关镇第一小学,115500.0\n",
      "佳县教育局,4655769.0014\n",
      "兰州市国土资源局,198000.0\n",
      "襄城县教体局,78579.0\n",
      "蚌埠市水利局,128000.0\n",
      "镇安县高级职业中学,314880.0\n",
      "保定市徐水区教育局,1179500.0\n",
      "大同市高速公路建设管理处,89360.0\n",
      "首都师范大学附属中学,2900980.0\n",
      "广宁县广宁第一中学,268000.0\n",
      "北京市平谷区教育考试中心,1245000.0\n",
      "NNZC2014-10675A-C南宁市现代教育技术中心,899960.0\n",
      "上海防灾救灾研究所,645700.0\n",
      "铜川市公安局,117800.0\n",
      "襄城县司法局,89128.0\n",
      "张掖市地方税务局,401790.0\n",
      "祥云县人民医院,303268.0\n",
      "上海健生教育配置招标有限公司采购信息—有关上海市教委信息中心,274000.0\n",
      "洛阳市东升第二中学,320000.0\n",
      "河北省烟草公司,186810.0\n",
      "中央民族大学,292200.0\n",
      "东辽县司法局,81200.0\n",
      "民政局,643260.0\n",
      "石狮市蚶江镇莲埭小学,203000.0\n",
      "北京市八一中学,1400000.0\n",
      "广州市海珠区地方税务局,965000.0\n",
      "高阳县教育局,2054050.0\n",
      "YS2015-ZB181永胜县仁和镇中心,219450.0\n",
      "宁夏医科大学总医院数据中心,526800.0\n",
      "广西创建工程招投标造价咨询有限责任公司,1135700.0\n",
      "珠海出入境边防检查总站,8642520.0\n",
      "东辽县公安局,164430.0\n",
      "迁安市城区街道办事处,53640.0\n",
      "红河州公安局,2000600.0\n",
      "无锡市政府采购中心,4346000.0\n",
      "绥德县人工影响天气领导小组办公室,78565.0\n",
      "商丘市文化路小学,526400.0\n",
      "中华会计函授学校榆林分校,356000.0\n",
      "双江自治县民政局,111750.0\n",
      "上海中医药大学,910000.0\n",
      "重庆市第二中级人民法院,258000.0\n",
      "上海海关,2280000.0\n",
      "西安文理学院,1248320.0\n",
      "三门峡市高级技工学校,389000.0\n",
      "广东省公安厅机关政府采购管理办公室,1777200.0\n",
      "渭源县兰渭希望小学,886280.0\n",
      "铜川市王益区财政局,88500.0\n",
      "深圳市电子政务资源中心,247000.0\n",
      "中国银行业监督管理委员会,2783000.0\n",
      "关于FZ2015HW165-1福州市传染病医院,483836.0\n",
      "兰州市统计局,552320.0\n",
      "张掖市甘州区地方税务局,1289000.0\n",
      "潮南区井都第一初级中学、潮南区井都镇古埕小学、潮南区井都镇和丰小学、潮南区井都镇平湖西小学、潮南区井都镇上南小学、潮南区井都镇神山小学、潮南区井都镇诗家小学、潮南区井都镇新明小学；,1267619.8\n",
      "广东省地方税务局,649600.0\n",
      "佛山市南海区大沥镇盐步初级中学,385900.0\n",
      "抚顺市污水排放监察收费管理中心,17940.0\n",
      "北京市朝阳区现代教育技术信息网络中心,5303560.0\n",
      "安阳市殷都区政府所,10620.0\n",
      "烟台市牟平区人民法院,208700.0\n",
      "关于苏州市老年大学,517913.5\n",
      "从化市地方税务局,702000.0\n",
      "商水县农村义务教育薄弱学校,801875.0\n",
      "河南省商务中等职业学校,894610.0\n",
      "安阳县韩陵镇中心,84980.0\n",
      "永城市第二初级中学,164000.0\n",
      "青岛采购招标中心,286800.0\n",
      "广东省国家税务局,1062900.0\n",
      "国家开发银行股份有限公司,1050000.0\n",
      "璧山县公安消防大队,160668.0\n",
      "辽宁省抚顺市住房公积金管理中心,19500.0\n",
      "重庆市公安局大渡口区分局,464839.0\n",
      "（成交结果公告）阜新市公安局,51500.0\n",
      "邢台市公安局开发区分局,1040000.0\n",
      "博爱县职业中等专业学校,19200.0\n",
      "南皮县教育局,1035150.0\n",
      "铁岭市外事学校,148000.0\n",
      "西安工程大学,228000.0\n",
      "合水县统计局,232000.0\n",
      "永登县第一中学,318400.0\n",
      "府谷县农村经营管理站,99700.0\n",
      "西安市灞桥区财政局,51200.0\n",
      "贺州市政府采购招投标中心,210590.0\n",
      "铁岭市工商局,58590.0\n",
      "勐海县环境保护局,137600.0\n",
      "双江自治县第一完全中学,386100.0\n",
      "哈尔滨市燎原学校,269900.0\n",
      "宁夏回族自治区政府采购中心,67200.0\n",
      "中山市坦洲理工学校,546360.0\n",
      "广西科联招标中心,734350.0\n",
      "河南省鹤壁市淇滨区人力资源和社会保障局,99600.0\n",
      "新乡市委办公室,26000.0\n",
      "回龙镇教育经费结算中心,1698472.0\n",
      "榆树市第二实验中学,178200.0\n",
      "临沂市兰山区教育体育局,231910.0\n",
      "尚志市教育局,546000.0\n",
      "南阳市第十五小学,684000.0\n",
      "塔河县第二中学,67220.0\n",
      "西安石油大学,116800.0\n",
      "横山县第二小学,381060.0\n",
      "汕头市潮南区两英镇墙新学校,1861563.0\n",
      "南京市政府采购中心关于南京市财政局,1168000.0\n",
      "中山市东凤镇文化传播管理有限公司,135800.0\n",
      "林州市机关事业单位工作人员社会保险管理处,93560.0\n",
      "武汉市江汉区民政局,476000.0\n",
      "西安市新城区公安局站前分局  联系人：袁博,147700.0\n",
      "汕头市公安局,1049380.0\n",
      "临沂市兰陵县统计局,68760.0\n",
      "辽宁省水文局,1545000.0\n",
      "永善县教育局,417360.0\n",
      "灵台县教育局,4881800.0\n",
      "中山市西区宣传文体服务中心,279000.0\n",
      "中国远东国际招标公司,490240.0\n",
      "黑河市教育局,529750.0\n",
      "阳江市文化广电新闻出版局,852475.0\n",
      "宣化县教育体育局,2909850.0\n",
      "汕头市澄海莲阳中学、汕头市澄海苏湾中学、汕头市澄海澄华中学、汕头市澄海盐鸿中学、汕头市澄海隆都中学、汕头市澄海凤翔中学、汕头市澄海莱芜中学、汕头市澄海溪南中学；,228120.0\n",
      "深圳龙达招标有限公司,146000.0\n",
      "江苏省省级行政机关政府采购中心,1350700.0\n",
      "固原市原州区人民医院,150000.0\n",
      "重庆市璧山中学校,2282400.0\n",
      "铜川职业技术学院,1590000.0\n",
      "上海市绿化和市容管理信息中心,150000.0\n",
      "抚顺市公安局,167430.0\n",
      "大同市人民政府办公厅,26290.0\n",
      "西安?灞生态区管理委员会,1076900.0\n",
      "襄城县紫云镇中心,26450.0\n",
      "河南工业大学,143600.0\n",
      "郑州高新区管委会教育局,1142600.0\n",
      "镇原县南区小学,224720.0\n",
      "平顶山市房产管理局,518000.0\n",
      "青田县教育局,5838000.0\n",
      "关于彬县县医院,187000.0\n",
      "云和县住房和城乡建设局,85000.0\n",
      "铁岭市民政局,14980.0\n",
      "靖边县影剧院,122450.0\n",
      "北京市平谷区卫生和计划生育委员会,2010000.0\n",
      "上海旅游高等专科学校,145000.0\n",
      "佛山市南海区大沥镇沙溪小学,496897.0\n",
      "迁安市教育局,1761625.0\n",
      "大同市审计局,17940.0\n",
      "内乡县公共资源交易中心,154000.0\n",
      "NNZC2014-10044A南宁市中级人民法院,2535000.0\n",
      "汉滨区江南中心校,1748688.0\n",
      "内乡县商务局,242800.0\n",
      "广州市花都区地方税务局,1818210.0\n",
      "蔚县职业技术教育中心,163500.0\n",
      "广州市天河区地方税务局,989860.0\n",
      "北京市东城区教育技术装备部,1434920.0\n",
      "中国人民武装警察部队唐山市消防支队,251600.0\n",
      "大同市公安局南郊区分局,222750.0\n",
      "舞阳县公安局,345700.0\n",
      "西安市西光中学  联系人：孙鹏,12160.0\n",
      "临泽县人民法院,300000.0\n",
      "济源市交通运输局,195500.0\n",
      "张家口市宣化区加强和创新社会管理工作领导小组办公室,500000.0\n",
      "贺州市政府采购招投标中心关于贺州市国土局,278000.0\n",
      "抚顺市非税收入管理局,195400.0\n",
      "濮阳市第一高级中学,58900.0\n",
      "NZC/A150051宁夏医科大学总医院数据中心,526800.0\n",
      "靖边县公安局,169360.0\n",
      "中山市卓山中学,95000.0\n",
      "内蒙古赤峰市元宝山区政府采购中心,682740.0\n",
      "陕西省国家税务局,5384610.0\n",
      "鹤山市古劳中学,292125.0\n",
      "青岛市教育局,367000.0\n",
      "河南省南阳市八中学,288750.0\n",
      "宁波市国家税务局,605400.0\n",
      "靖边县第二幼儿园,258270.0\n",
      "辽宁省基础地理信息中心,678000.0\n",
      "西安市华山中学  联系人：周超,87140.0\n",
      "周口市六一路小学,355500.0\n",
      "河北工业大学,463900.0\n",
      "佛山市南海区大沥镇奇槎小学,345830.0\n",
      "石家庄市八一小学,385820.0\n",
      "磁县实验学校,478800.0\n",
      "嘉兴市国土资源局,155000.0\n",
      "中国医科大学附属第一医院服务器（信息中心,500000.0\n",
      "商丘高级技工学校,628000.0\n",
      "南京农业大学,216680.0\n",
      "郑州市财政局信息中心,1110000.0\n",
      "志丹县高级中学,407760.0\n",
      "内蒙古赤峰市元宝山区政府采购中心关于赤峰市元宝山区招商局,22295.0\n",
      "安阳市疾病预防控制中心,69475.0\n",
      "北京市公安局,2662176.0\n",
      "中山市公安局,208900.0\n",
      "黑龙江省农垦总局,196350.0\n",
      "渭源县农牧局,299820.0\n",
      "兰州市文广局,367400.0\n",
      "毕节市公共资源交易中心关于毕节市公安局,444444.0\n",
      "嘉兴市南湖区城南街道禾源社区居民委员会,18000.0\n",
      "肇庆市第一小学,240800.0\n",
      "抚顺市审计局,41600.0\n",
      "克什克腾旗人口和计划生育局,781810.0\n",
      "苏州诚和招投标咨询有限公司关于苏州市公安局,1596600.0\n",
      "金华市西苑小学,377520.0\n",
      "苍山县人民法院,329800.0\n",
      "抚顺市疾病预防控制中心,10783.0\n",
      "高要市人民法院,168000.0\n",
      "上海海潮新技术研究所,149650.0\n",
      "汕头市潮南区井都中学,3579156.5\n",
      "河南正高科贸有限公司,49820.0\n",
      "中国科普研究所,1298900.0\n",
      "旬阳县城关小学,328520.0\n",
      "山东中钢招标有限公司,663800.0\n",
      "肇庆市实验小学,242920.0\n",
      "湖南智埔工程咨询有限公司,564300.0\n",
      "广州体育学院,575660.0\n",
      "佳县科学技术局,103800.0\n",
      "中国科学院,2313060.0\n",
      "白银市靖远县教育局,535100.0\n",
      "红河卫生职业学院,750960.0\n",
      "迁安市环境保护局,151900.0\n",
      "长葛市实验小学,272000.0\n",
      "英德市下太学校,497492.0\n",
      "兵团社会主义学院,645250.0\n",
      "延安大学,1139500.0\n",
      "临颍县工商局,86000.0\n",
      "北京市石景山区人民法院,1733000.0\n",
      "贺兰县文化旅游广播电视局,1595660.0\n",
      "重庆市沙坪坝区陈家桥医院,317800.0\n",
      "周至县教育局,600000.0\n",
      "新乡县第一中学,96000.0\n",
      "深圳市国家税务局,1537100.0\n",
      "上海浦成机电设备招标有限公司采购信息——关于上海外国语大学,568500.0\n",
      "长葛市国土资源局,168660.0\n",
      "河南省国土资源电子政务中心,672000.0\n",
      "西安市第八十九中学    联系人：崔勇,119850.0\n",
      "兰州市第二十七中学,188000.0\n",
      "福建云锋招标有限公司关于石狮市教育局,1375130.0\n",
      "海关,1125800.0\n",
      "洛阳市东方高级中学,832500.0\n",
      "北京教育考试院,695797.0\n",
      "铁岭市教育局,137700.0\n",
      "许昌市大同街小学,198000.0\n",
      "重庆农村土地交易所,239800.0\n",
      "佛山市南海区大沥镇邵边小学,661740.0\n",
      "武汉市汉阳区铁桥小学,134400.0\n",
      "甘肃省民乐县第一中学,1200000.0\n",
      "市南区教育网络中心,2298000.0\n",
      "中山火炬职业技术学院,633650.0\n",
      "肥城市中小学,1144480.0\n",
      "郑州市二七区淮河东路小学,156000.0\n",
      "石家庄高新技术产业开发区就业服务局,87996.0\n",
      "绥德县广播电视台,198400.0\n",
      "广西科文招标有限公司,518300.0\n",
      "中国人民银行,437000.0\n",
      "宿迁市船员计算机考试中心,1641730.0\n",
      "东辽县社会保险局,283000.0\n",
      "汕头市潮南区成田镇上蓝汀小学,498814.7\n",
      "广西建澜工程招标有限公司,70000.0\n",
      "临颍县公安局,212800.0\n",
      "焦作市马村区教育局,581000.0\n",
      "北华航天工业学院,955300.0\n",
      "靖边县第四中学,202980.0\n",
      "和龙市煤炭事业管理局,67300.0\n",
      "黑龙江农垦科技职业学院,970100.0\n",
      "中国农业发展银行,1611159.0\n",
      "西峡县国土资源局,119500.0\n",
      "NNZC2015-10395AA南宁市现代教育技术中心,1049300.0\n",
      "万全县教育和科学技术局,1290400.0\n",
      "建湖县公安局,156800.0\n",
      "襄阳市档案局,10820.0\n",
      "石嘴山市市委组织部,75900.0\n",
      "驻马店市艺术职业中等专业学校,167400.0\n",
      "枞阳县司法局,130320.0\n",
      "水利部水利信息中心,160000.0\n",
      "泰安市食品药品检验检测中心,295000.0\n",
      "抚顺市产品质量监督检验所,26245.0\n",
      "顺义区人民法院,1350000.0\n",
      "兰州市文化广播影视新闻出版局,479118.0\n",
      "无锡市政府采购中心关于江苏省无锡地方税务局,1331380.0\n",
      "贵州省国家税务局,3968720.0\n",
      "山西省大同市中级人民法院,17950.0\n",
      "南阳市公安局,1318170.0\n",
      "红河州审计局,760000.0\n",
      "郑州市地方税务局,435000.0\n",
      "洛阳市老城区教育局,350000.0\n",
      "甘肃省人民医院,4800000.0\n",
      "威海市公安局,952000.0\n",
      "榆林高新技术产业开发区管理委员会,1324800.0\n",
      "中山市人民政府石岐区办事处,677800.0\n",
      "临沧高级技工学校,1138785.0\n",
      "阳春市口腔医院,907000.0\n",
      "泰州市姜堰区教育局,462600.0\n",
      "哈尔滨市社会主义学院,374500.0\n",
      "靖边县新闻中心,90890.0\n",
      "青岛市公安局,3230025.0\n",
      "海安县曲塘中学,298870.0\n",
      "关于黑龙江省垦区公安局,189380.0\n",
      "伊金霍洛旗新闻中心,310000.0\n",
      "江苏省苏州市中级人民法院,1818000.0\n",
      "大冶市教育局,204500.0\n",
      "重庆交通大学,667200.0\n",
      "渭南市互联网信息办公室,430000.0\n",
      "迁安市就业服务局,391600.0\n",
      "广东省教育装备中心教育采购管理办公室,1682950.0\n",
      "黑河小学,254600.0\n",
      "吉林北泰建设工程咨询有限公司,314100.0\n",
      "阜阳市颍泉区司法局,109200.0\n",
      "城口县公共资源交易中心,90400.0\n",
      "NNZC2014-10675A-B南宁市现代教育技术中心,198400.0\n",
      "甘肃省电化教育中心,1025000.0\n",
      "兰州市第六中学,275100.0\n",
      "济源职业技术学院,405900.0\n",
      "安徽省阜阳第一中学,263940.0\n",
      "大方县人民政府政务服务中心关于大方县文化广播电视旅游局,173000.0\n",
      "靖边县妇幼保健院,408500.0\n",
      "周口市人事培训中心,379800.0\n",
      "宝鸡市市级部分单位,372500.0\n",
      "横山县城关小学,519600.0\n",
      "教育网络中心,6793355.0\n",
      "林州市市直第七小学,21400.0\n",
      "蠡县教育局,270000.0\n",
      "北京市铁路第二中学,1000800.0\n",
      "陕西省图书馆,948000.001\n",
      "辽宁省高级人民法院,1204065.0\n",
      "许昌市招标投标交易管理中心,94900.0\n",
      "北京市西城区教育技术装备中心,4230450.0\n",
      "伊金霍洛旗就业服务局,58050.0\n",
      "南宁市华东招标有限责任公司关于广西海事局,3198138.0\n",
      "金华市公安局,423420.0\n",
      "襄城县范湖乡中心,38232.0\n",
      "中共抚顺市委抚顺市人民政府信访局,70250.0\n",
      "吉林省恒一项目管理工程咨询有限公司,326200.0\n",
      "榆中县食品药品监督管理局,180600.0\n",
      "南京航空航天大学,484000.0\n",
      "武汉市国土资源和规划信息中心,144000.0\n",
      "恩施州综合招标投标（政府采购）交易中心,178400.0\n",
      "陕西省地方税务局直属税务分局,1036134.0\n",
      "濮阳市房地产管理中心,63360.0\n",
      "伊金霍洛旗人民法院,36800.0\n",
      "项城市第一实验小学,257920.0\n",
      "甘肃省中医院,349800.0\n",
      "广西新宇建设项目管理有限公司,173250.0\n",
      "广西云龙招标有限公司,1936230.0\n",
      "肇庆市第八中学,192500.0\n",
      "黑龙江农垦职业学院,266000.0\n",
      "莱州市人民法院,186675.0\n",
      "延庆县教育信息中心,2693600.0\n",
      "清原县教育局,1119800.0\n",
      "泾川县党原乡中学,168000.0\n",
      "汕头市澄海莲下北湾开智小学、澄海莲下中心小学,535418.0\n",
      "海安县公共资源交易中心,149435.0\n",
      "广西建通工程咨询有限责任公司,510000.0\n",
      "临颍县第三高级中学,54080.0\n",
      "庆阳市庆化学校,485000.0\n",
      "楚雄市人民政府扶贫开发办公室,179010.0\n",
      "榆林市不动产登记局,350000.0\n",
      "大同市非税收入管理局,13570.0\n",
      "新乡市公安局,55300.0\n",
      "中央财经大学,890000.0\n",
      "上海浦成机电设备招标有限公司采购信息——关于上海海洋大学,346000.0\n",
      "广东省体育局,2145760.0\n",
      "广西创建项目咨询有限公司,1173532.46\n",
      "商丘市司法局,179250.0\n",
      "上海科技大学,1160000.0\n",
      "NNZC2015-10395AC南宁市现代教育技术中心,499500.0\n",
      "云南省第一人民医院,149900.0\n",
      "榆阳区教育局,463000.0\n",
      "北京教育网络和信息中心,7090000.0\n",
      "石家庄市长安区人民法院,266650.0\n",
      "河南信息工程学校,714000.0\n",
      "咸阳职业技术学院,314910.0\n",
      "莱芜市莱城区司法局,143560.0\n",
      "榆林市第二中学,140415.0\n",
      "白沟镇总校,461480.0\n",
      "中山市黄圃镇对甫小学,101280.0\n",
      "西峡县人民法院,227980.0\n",
      "海关总署物资装备采购中心,859400.0\n",
      "陕西科技大学,293000.0\n",
      "南郑县市场监督管理局,342990.0\n",
      "广东省广宁县地方税务局,531300.0\n",
      "上海市黄浦区电子政务管理中心,398000.0\n",
      "NNZC2015-10395AB南宁市现代教育技术中心,888000.0\n",
      "兴化市招投标交易中心,366600.0\n",
      "魏都区政府采购中心,320000.0\n",
      "湖北省国家税务局,718000.0\n",
      "永城市教育体育局,854200.0\n",
      "广东省高要市地方税务局,172000.0\n",
      "肇庆市第一中学,1294620.0\n",
      "惠州广播电视传媒集团有限公司,323000.0\n",
      "昆明海关机关服务中心,202000.0\n",
      "周口市七一路第二小学,451200.0\n",
      "许昌市人力资源社会保障电子政务中心,132000.0\n",
      "铁岭市新城区管委会财政局,20920.0\n",
      "东兴市东兴中学,224600.0\n",
      "西安市新城区考核办  联系人：张倩,44380.0\n",
      "海宁市政府采购中心,233680.0\n",
      "青海省国家税务局,574300.0\n",
      "SJC2014040098市国税局,105000.0\n",
      "榆林市农村经营管理中心,226900.0\n",
      "浙江省烟草公司丽水市公司,1578000.0\n",
      "中共绥德县委办公室,260530.0\n",
      "石家庄市桥西区卫生监督所,155572.0\n",
      "江苏建协工程咨询有限公司关于2013年排水公司设备、设施大中修项目（第一批）——管网运营分公司生产调度中心,393000.0\n",
      "凤县中学,574360.0\n",
      "上海市高级技工学校,24680.0\n",
      "关于洛阳旅游学校,316000.0\n",
      "西安市新城区财政局,1077610.0\n",
      "济源市特殊教育学校,88200.0\n",
      "洋县供销合作社,586800.0035\n",
      "中宁县会计核算中心,264800.0\n",
      "清涧县公安局,247500.0\n",
      "吉林省恒一项目管理工程咨询有限公司关于长春市第八十七中学,495000.0\n",
      "临夏县教育局,2870166.0\n",
      "石家庄市桥西区司法局,69860.0\n",
      "陕西电大绥德辅导站,155200.0\n",
      "江城县思源实验学校,786000.0\n",
      "中国医科大学,717000.0\n",
      "广西鑫磐工程项目管理有限责任公司关于昭平县民政局,191040.0\n",
      "襄城县农村公路管理所,16500.0\n",
      "平阳县公安局,807600.0\n",
      "濮阳市政府采购中心,917240.0\n",
      "陕西国防工业职业技术学院,350000.0\n",
      "迁安市地方税务局,123700.0\n",
      "濮阳经济技术产业集聚区建设领导小组办公室所,82950.0\n",
      "中山职业技术学院,295600.0\n",
      "NNZC2014-11019A南宁市中级人民法院,4214580.0\n",
      "永城市环保局,78000.0\n",
      "兰州市第十二中学,658500.0\n",
      "中国共产党临沂市莒南县委员会组织部党员教育中心,226000.0\n",
      "临沧市公安局,275000.0\n",
      "保定市北市区东金庄乡人民政府,111800.0\n",
      "石嘴山市公安局,897000.0\n",
      "临夏州公安局,137500.0\n",
      "阳山县教育局,1201620.0\n",
      "庆阳第五中学,2734720.0\n",
      "北京市怀柔区九渡河中学,805000.0\n",
      "上海健生教育配置招标有限公司采购信息—有关上海东海职业技术学院,508500.0\n",
      "北京师范大学,1558000.0\n",
      "抚顺市城市管理局,63700.0\n",
      "漯河市中级人民法院,24585.0\n",
      "兰州理工中等专业学校甘肃广播电视大学兰州分校兰州市第六中学机械工程专业数字化工厂实训系统及控制中心,228950.0\n",
      "云南省国家税务局,5977100.0\n",
      "北京市农村合作经济经营管理站,5048960.0\n",
      "张家口市桥西区利民小学,326592.0\n",
      "商丘市回民中学,1490000.0\n",
      "公主岭市财政局,2967800.0\n",
      "抚顺市统计局,16795.0\n",
      "濮阳市实验幼儿园所,357120.0\n",
      "甘肃省礼县第一中学,197620.0\n",
      "中招康泰项目管理有限公司,180000.0\n",
      "肇庆市商务技工学校,567550.0\n",
      "济源市公安局,46500.0\n",
      "江阴市政府采购中心,259000.0\n",
      "长葛市教育体育局,387400.0\n",
      "深圳外国语学校,488650.0\n",
      "中国科学院上海药物研究所,4248420.0\n",
      "汕头市澄海区莲华镇小学,719145.0\n",
      "北京市第十二中学,2386000.0\n",
      "中山市城乡规划局火炬开发区分局,288910.0\n",
      "榆林市第八小学,389300.0\n",
      "陆良县马街镇第二中学,124500.0\n",
      "上海浦成机电设备招标有限公司,435000.0\n",
      "武汉市武昌区教育局,821700.0\n",
      "国家税务总局,1306160.0\n",
      "贺州市政府采购招投标中心关于贺州市公安局,102800.0\n",
      "濮阳市第四中学,259350.0\n",
      "漯河市公安局,225000.0\n",
      "上海市奉贤区政府采购信息2013-251--有关奉贤区教育局,1236750.0\n",
      "铜川市卫生监督处,84080.0\n",
      "河南省安阳市中级人民法院,50500.0\n",
      "庆阳第七中学,279770.0\n",
      "孟津县第一高级中学,192950.0\n",
      "迁安市建筑工程质量监督检测站,70500.0\n",
      "肇庆市端城小学,248230.0\n",
      "林州市环境保护局,195080.0\n",
      "新疆生产建设兵团信息技术服务中心,2160000.0\n",
      "漯河市召陵区行政服务中心,237000.0\n",
      "北京市大兴区财政局,1896800.0\n",
      "福建国诚招标有限公司,192300.0\n",
      "河南盛华会计师事务所有限公司,79600.0\n",
      "中共桦甸市委党校所,319400.0\n",
      "濮阳市华龙区人口和计划生育委员会所,94000.0\n",
      "宜阳县人民法院,279500.0\n",
      "新华网股份有限公司,5045000.0\n",
      "辽宁中医药大学,700000.0\n",
      "云和县教育装备和勤工俭学办公室,399700.0\n",
      "=========Amount====\n",
      "0\n",
      "=====province========\n",
      "青海,574300.0\n",
      "辽宁,5827065.0\n",
      "贵州,3968720.0\n",
      "北京,40500463.0\n",
      "广西,9640540.46\n",
      "广东,8021710.0\n",
      "上海,15812160.0\n",
      "云南,7845000.0\n",
      "甘肃,9289090.0\n",
      "山东,663800.0\n",
      "安徽,263940.0\n",
      "宁夏,2093700.0\n",
      "湖南,564300.0\n",
      "河北,4053315.0\n",
      "吉林,1284000.0\n",
      "黑龙江,1621830.0\n",
      "福建,1567430.0\n",
      "江苏,4893080.0\n",
      "陕西,11646944.001\n",
      "山西,17950.0\n",
      "新疆,2160000.0\n",
      "重庆,1733868.0\n",
      "内蒙,705035.0\n",
      "湖北,2107949.0\n",
      "河南,4682660.0\n",
      "浙江,1578000.0\n"
     ]
    }
   ],
   "source": [
    "#coding = utf-8\n",
    "infile = open('ccgp_it_result.csv')\n",
    "supplier_dic = {}\n",
    "consumer_dic = {}\n",
    "amount_list = []\n",
    "year_dic = {}\n",
    "provinces = ['北京', '天津市', '上海', '重庆', '河北', '山西', '辽宁', '吉林', '黑龙江', '江苏', '浙江', '安徽', '福建', '江西', '山东', '河南', '湖北', '湖南', '广东', '海南', '四川', '贵州', '云南', '陕西','甘肃','青海','台湾','内蒙','广西','西藏','宁夏','新疆']\n",
    "institute = ['局','中心', '小学','中学','大学','学校','学院','公司','处', '法院','处','医院','银行','所', '海关']\n",
    "prov_dic = {}\n",
    "\n",
    "gg_types = ['需求', '招标', '更正', '中标', '废标']\n",
    "gg_item_dic = {}\n",
    "for item in gg_types:\n",
    "    gg_item_dic[item] = set()\n",
    "gg_item_dic['其它'] = set()\n",
    "\n",
    "#outfile_amount = open('amount', 'w')\n",
    "def change_amount(input_str):\n",
    "    strtmp = ''\n",
    "    for loc in input_str:\n",
    "        if loc.isdigit() or loc == '.':\n",
    "            strtmp = strtmp + loc\n",
    "    try:\n",
    "        strtmp = float(strtmp)\n",
    "        if strtmp < 1000:\n",
    "            strtmp = strtmp * 10000\n",
    "        return strtmp\n",
    "    except:\n",
    "        return 0\n",
    "\n",
    "def get_year(input_str):\n",
    "    input_str = input_str.strip().split('年')\n",
    "    try:\n",
    "        return int(input_str[0].strip())\n",
    "    except:\n",
    "        return 0\n",
    "\n",
    "def get_province(input_str):\n",
    "    for item in provinces:\n",
    "        if item in input_str:\n",
    "            return item\n",
    "    return 0\n",
    "\n",
    "def get_consumer(input_str):\n",
    "    for item in institute:\n",
    "        if item in input_str:\n",
    "            input_str = input_str.strip().split(item)\n",
    "            return input_str[0].strip() + item       \n",
    "    return 'NA'\n",
    "    \n",
    "\n",
    "for line in infile:\n",
    "    title, consumer, time, supplier, amount, content  = line.strip().split('\\t')\n",
    "    \n",
    "    if time != 'NA':\n",
    "        time = get_year(time)\n",
    "        if time != 0:\n",
    "            if time not in year_dic:\n",
    "                year_dic[time] = 1\n",
    "            else:\n",
    "                year_dic[time] += 1\n",
    "    if amount != 'NA':\n",
    "        amount = change_amount(amount)\n",
    "        \n",
    "        #print >> outfile_amount, amount\n",
    "        if amount > 10000 and amount < 10000000:\n",
    "            amount_list.append(amount)\n",
    "        else:\n",
    "            amount = 0\n",
    "    else:\n",
    "        continue\n",
    "    if title != 'NA':\n",
    "        prov = get_province(title)\n",
    "        if prov != 0:\n",
    "            if prov not in prov_dic:\n",
    "                prov_dic[prov] = amount\n",
    "            else:\n",
    "                prov_dic[prov] += amount\n",
    "    if supplier != 'NA':\n",
    "        if supplier not in supplier_dic:\n",
    "            #supplier_dic[supplier] = amount\n",
    "            supplier_dic[supplier] = 1\n",
    "        else:\n",
    "            #supplier_dic[supplier] += amount\n",
    "            supplier_dic[supplier] += 1\n",
    "\n",
    "    if consumer == 'NA':\n",
    "        consumer = get_consumer(title)\n",
    "        \n",
    "    if consumer != 'NA':\n",
    "        if consumer not in consumer_dic:\n",
    "            consumer_dic[consumer] = amount\n",
    "            #consumer_dic[consumer] = 1\n",
    "        else:\n",
    "            consumer_dic[consumer] += amount\n",
    "            #consumer_dic[consumer] += 1\n",
    "    \n",
    "        \n",
    "            \n",
    "print \"=========Supplier============\"\n",
    "outfile = open('supplier_count', 'w')\n",
    "for supplier in supplier_dic:\n",
    "    if supplier_dic[supplier] > 1:\n",
    "        print supplier + ',' + str(supplier_dic[supplier])\n",
    "        #pass\n",
    "print \"=========Consumer============\"\n",
    "outfile = open('consumer_count', 'w')\n",
    "for consumer in consumer_dic:\n",
    "    if consumer_dic[consumer] > 1:\n",
    "        print consumer + ',' + str(consumer_dic[consumer])\n",
    "        pass\n",
    "print \"=========Amount====\"\n",
    "print amount_count\n",
    "print \"=====province========\"\n",
    "for prov in prov_dic:\n",
    "    if prov_dic[prov] > 1:\n",
    "        print prov + ',' + str(prov_dic[prov])\n",
    "        pass"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{0: 0.839563862928349, 1: 0.16043613707165108, 2: 0.06542056074766354, 3: 0.03271028037383177, 4: 0.02336448598130841, 5: 0.014018691588785047}\n"
     ]
    }
   ],
   "source": [
    "amount_dic = {}\n",
    "amount_dic[0] = 0\n",
    "amount_dic[1] = 0\n",
    "amount_dic[2] = 0\n",
    "amount_dic[3] = 0\n",
    "amount_dic[4] = 0\n",
    "amount_dic[5] = 0\n",
    "\n",
    "for amount in amount_list:\n",
    "    if amount < 1000000:\n",
    "        amount_dic[0] += 1\n",
    "    if amount >= 1000000 < 2000000:\n",
    "        amount_dic[1] += 1\n",
    "    if amount >= 2000000 < 3000000:\n",
    "        amount_dic[2] += 1\n",
    "    if amount >= 3000000 < 4000000:\n",
    "        amount_dic[3] += 1\n",
    "    if amount >= 4000000 < 5000000:\n",
    "        amount_dic[4] += 1\n",
    "    if amount >= 5000000:\n",
    "        amount_dic[5] += 1\n",
    "for item in amount_dic:\n",
    "    amount_dic[item] = amount_dic[item]/float(len(amount_list))\n",
    "print amount_dic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{0: 2880, '\\xe9\\x9d\\x92\\xe6\\xb5\\xb7': 7, '\\xe8\\xbe\\xbd\\xe5\\xae\\x81': 12, '\\xe8\\xb4\\xb5\\xe5\\xb7\\x9e': 15, '\\xe5\\x8c\\x97\\xe4\\xba\\xac': 44, '\\xe5\\xb9\\xbf\\xe8\\xa5\\xbf': 64, '\\xe5\\xb9\\xbf\\xe4\\xb8\\x9c': 55, '\\xe4\\xb8\\x8a\\xe6\\xb5\\xb7': 36, '\\xe6\\xb5\\xb7\\xe5\\x8d\\x97': 8, '\\xe7\\x94\\x98\\xe8\\x82\\x83': 18, '\\xe5\\xb1\\xb1\\xe4\\xb8\\x9c': 53, '\\xe5\\xae\\x89\\xe5\\xbe\\xbd': 3, '\\xe6\\xb1\\x9f\\xe8\\xa5\\xbf': 81, '\\xe5\\xa4\\xa9\\xe6\\xb4\\xa5\\xe5\\xb8\\x82': 2, '\\xe5\\xae\\x81\\xe5\\xa4\\x8f': 12, '\\xe7\\xa6\\x8f\\xe5\\xbb\\xba': 137, '\\xe6\\xb2\\xb3\\xe5\\x8c\\x97': 22, '\\xe8\\xa5\\xbf\\xe8\\x97\\x8f': 2, '\\xe5\\x90\\x89\\xe6\\x9e\\x97': 23, '\\xe9\\xbb\\x91\\xe9\\xbe\\x99\\xe6\\xb1\\x9f': 11, '\\xe6\\xb9\\x96\\xe5\\x8d\\x97': 9, '\\xe6\\xb1\\x9f\\xe8\\x8b\\x8f': 11, '\\xe9\\x99\\x95\\xe8\\xa5\\xbf': 10, '\\xe5\\xb1\\xb1\\xe8\\xa5\\xbf': 2, '\\xe6\\x96\\xb0\\xe7\\x96\\x86': 1, '\\xe5\\x9b\\x9b\\xe5\\xb7\\x9d': 1, '\\xe9\\x87\\x8d\\xe5\\xba\\x86': 45, '\\xe5\\x86\\x85\\xe8\\x92\\x99': 4, '\\xe6\\xb9\\x96\\xe5\\x8c\\x97': 6, '\\xe6\\xb2\\xb3\\xe5\\x8d\\x97': 38, '\\xe6\\xb5\\x99\\xe6\\xb1\\x9f': 42, '\\xe4\\xba\\x91\\xe5\\x8d\\x97': 27}\n"
     ]
    }
   ],
   "source": [
    "print prov_dic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{2016: 0.0575, 2017: 0.005, 2013: 0.2075, 2014: 0.3525, 2015: 0.3775}\n"
     ]
    }
   ],
   "source": [
    "total_count = 0\n",
    "for item in year_dic:\n",
    "    total_count = total_count + year_dic[item]\n",
    "for item in year_dic:\n",
    "    year_dic[item] = year_dic[item]/float(total_count)\n",
    "print year_dic"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "input_str = '黑龙江农垦科技职业学院笔记本电脑采购项目'\n",
    "get_province(input_str)\n",
    "'黑龙江' in input_str"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "青海\t0.00873907615481\n",
      "辽宁\t0.0149812734082\n",
      "贵州\t0.0187265917603\n",
      "北京\t0.0549313358302\n",
      "广西\t0.0799001248439\n",
      "广东\t0.0686641697878\n",
      "上海\t0.0449438202247\n",
      "海南\t0.00998751560549\n",
      "甘肃\t0.0224719101124\n",
      "山东\t0.0661672908864\n",
      "安徽\t0.00374531835206\n",
      "江西\t0.101123595506\n",
      "天津市\t0.00249687890137\n",
      "宁夏\t0.0149812734082\n",
      "福建\t0.171036204744\n",
      "河北\t0.0274656679151\n",
      "西藏\t0.00249687890137\n",
      "吉林\t0.0287141073658\n",
      "黑龙江\t0.0137328339576\n",
      "湖南\t0.0112359550562\n",
      "江苏\t0.0137328339576\n",
      "陕西\t0.0124843945069\n",
      "山西\t0.00249687890137\n",
      "新疆\t0.00124843945069\n",
      "四川\t0.00124843945069\n",
      "重庆\t0.0561797752809\n",
      "内蒙\t0.00499375780275\n",
      "湖北\t0.00749063670412\n",
      "河南\t0.0474406991261\n",
      "浙江\t0.0524344569288\n",
      "云南\t0.0337078651685\n"
     ]
    }
   ],
   "source": [
    "total_count = 0\n",
    "for item in prov_dic:\n",
    "    total_count = total_count + prov_dic[item]\n",
    "for item in prov_dic:\n",
    "    prov_dic[item] = prov_dic[item]/float(total_count)\n",
    "for item in prov_dic:\n",
    "    print item.decode('utf-8') + '\\t' + str(prov_dic[item])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
